Á¤º¸Ã³¸®ÇÐȸ ³í¹®Áö ÄÄÇ»ÅÍ ¹× Åë½Å½Ã½ºÅÛ
Current Result Document :
ÇѱÛÁ¦¸ñ(Korean Title) |
SSD»ó¿¡¼ ÇؽÃÁ¶ÀÎ Àӽà ÆÄÀÏÀÇ È¿°úÀûÀÎ °ü¸®¸¦ À§ÇÑ ºí·Ï ÇÒ´ç ¹æ¹ý |
¿µ¹®Á¦¸ñ(English Title) |
Block Allocation Method for Efficiently Managing Temporary Files of Hash Joins on SSDs |
ÀúÀÚ(Author) |
¾ÈÈ¿ÁØ
ÀÌ»ó¿ø
Hyojun An
Sangwon Lee
±èÁØÅÂ
ÀÌ»ó¿ø
Joontae Kim
Sangwon Lee
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 11 NO. 12 PP. 0429 ~ 0436 (2022. 12) |
Çѱ۳»¿ë (Korean Abstract) |
¸Þ¸ð¸®º¸´Ù Å« ´ë¿ë·® Å×À̺íµé¿¡ ´ëÇØ ÇؽÃÁ¶ÀÎ(Hash Join) ¼öÇà ½Ã Àӽà ÆÄÀϵéÀ» »ý¼ºÇؼ Á¶ÀÎ °úÁ¤¿¡¼ ¹ß»ýÇÏ´Â Àӽà µ¥ÀÌÅÍ I/O¸¦ ¼öÇàÇÏ°í Á¶ÀÎ Á¾·á ½Ã¿¡ ±× ÆÄÀϵéÀ» »èÁ¦ÇÑ´Ù. º» ³í¹®¿¡¼´Â ÇؽÃÁ¶Àοë Àӽà ÆÄÀϵéÀ» Çϵåµð½ºÅ©°¡ ¾Æ´Ñ SSD»ó¿¡¼ °ü¸®ÇÒ ¶§, ÆÄÀÏ »ý¼º ½Ã fallocate ½Ã½ºÅÛ ÄÝ ¹× ÆÄÀÏ »èÁ¦ °ü·Ã trim ¿É¼ÇÀÌ ÇؽÃÁ¶ÀÎ ¼º´É¿¡ Å« ¿µÇâÀ» ¹ÌÄ¡´Â Á¡À» ¹àÈù´Ù. ±¸Ã¼ÀûÀ¸·Î ´ëÇ¥ÀûÀÎ ¿ÀǼҽº µ¥ÀÌÅͺ£À̽ºÀÎ PostgreSQLÀ» ÀÌ¿ëÇؼ ´Ù¾çÇÑ »ó¿ë ¹× ¿¬±¸¿ë SSD »ó¿¡¼ ÇؽÃÁ¶ÀÎ ¼öÇà ½Ã, Àӽà ÆÄÀϵ鿡 ´ëÇÑ fallocate ¹× trim ¿É¼Ç »ç¿ë ¿©ºÎ¿¡ µû¶ó µðÆúÆ® Á¶ÇÕ¿¡ ºñÇØ ÃÖ´ë ¾à 3~5¹è Á¶ÀÎ ¼º´É Çâ»óÀÌ °¡´ÉÇÔÀ» º¸ÀδÙ. ±×¸®°í, Àӽà ÆÄÀϵ鿡 ´ëÇÑ µÎ ¿É¼ÇÀÇ Á¶ÇÕ¿©ºÎ¿¡ µû¸¥ SSD³»ÀÇ ¾²±â ÁõÆø(Write Amplification)°ú Trim ¸í·É¾î ¿À¹öÇìµå°¡ Á¶ÀÎ ¼º´É¿¡ Å« ¿µÇâÀ» ¹ÌÄ¡´Â Á¡À» ÀÚ¼¼È÷ ºÐ¼®ÇÑ´Ù. |
¿µ¹®³»¿ë (English Abstract) |
Temporary files are generated when the Hash Join is performed on tables larger than the memory. During the join process, each temporary file is deleted sequentially after it completes the I/O operations. This paper reveals for that the fallocate system call and file deletion-related trim options significantly impact the hash join performance when temporary files are managed on SSDs rather than hard disks. The experiment was conducted on various commercial and research SSDs using PostgreSQL, a representative open-source database. We find that it is possible to improve the join performance up to 3 to 5 times compared to the default combination depending on whether fallocate and trim options are used for temporary files. In addition, we investigate the write amplification and trim command overhead in the SSD according to the combination of the two options for temporary files. |
Å°¿öµå(Keyword) |
Ç÷¡½Ã ¸Þ¸ð¸®
°¡ºñÁö Ä÷º¼Ç
ÆäÀÌÁö ºÐ¸®
Flash Memory
Garbage Collection
Page Separation
ÇؽÃÁ¶ÀÎ
Àӽà ÆÄÀÏ
SSD
Æ®¸²
fallocate
Hash Join
Temporary File
SSD
Trim
fallocate
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|